/*
 Navicat Premium Data Transfer

 Source Server         : dell
 Source Server Type    : MySQL
 Source Server Version : 80019
 Source Host           : localhost:3306
 Source Schema         : nacos_config

 Target Server Type    : MySQL
 Target Server Version : 80019
 File Encoding         : 65001

 Date: 16/05/2021 17:56:40
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for config_info
-- ----------------------------
DROP TABLE IF EXISTS `config_info`;
CREATE TABLE `config_info` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `data_id` varchar(255) COLLATE utf8_bin NOT NULL COMMENT 'data_id',
  `group_id` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `content` longtext COLLATE utf8_bin NOT NULL COMMENT 'content',
  `md5` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT 'md5',
  `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  `src_user` text COLLATE utf8_bin COMMENT 'source user',
  `src_ip` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT 'source ip',
  `app_name` varchar(128) COLLATE utf8_bin DEFAULT NULL,
  `tenant_id` varchar(128) COLLATE utf8_bin DEFAULT '' COMMENT '租户字段',
  `c_desc` varchar(256) COLLATE utf8_bin DEFAULT NULL,
  `c_use` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `effect` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `type` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `c_schema` text COLLATE utf8_bin,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_configinfo_datagrouptenant` (`data_id`,`group_id`,`tenant_id`)
) ENGINE=InnoDB AUTO_INCREMENT=152 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='config_info';

-- ----------------------------
-- Records of config_info
-- ----------------------------
BEGIN;
INSERT INTO `config_info` VALUES (14, 'coupon-service-dev.yml', 'DEFAULT_GROUP', 'coupon:\n    couponName: 开发环境的命名空间\n    couponNum: 99', '7fe59aef54663c22a980bb9e57766314', '2020-09-10 19:30:34', '2020-09-11 00:53:53', NULL, '0:0:0:0:0:0:0:1', '', '683f49c0-bbff-4a16-adbb-3794a65286e5', '', '', '', 'yaml', '');
INSERT INTO `config_info` VALUES (30, 'gateway.yml', 'dev', 'server:\n  port: 80', '02c6a1657a83f781f5d2a3b1fd3e882b', '2020-09-11 02:06:56', '2020-09-11 02:17:46', NULL, '0:0:0:0:0:0:0:1', '', '62664db1-9168-4f61-8c19-032ebfd6b6a2', '', '', '', 'yaml', '');
INSERT INTO `config_info` VALUES (35, 'product-category-service.yml', 'dev', 'spring:\n  datasource:\n    type: com.alibaba.druid.pool.DruidDataSource\n#    #MySQL配置\n    driverClassName: com.p6spy.engine.spy.P6SpyDriver\n    url: jdbc:p6spy:mysql://127.0.0.1:3306/pms_category?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=Asia/Shanghai\n    username: root\n    password: orochi0208\n  redis:\n    host: 192.168.50.190\n    port: 6379\n    database: 5  ', '012eb12ebc8272cabc5ab7348089be37', '2020-09-11 12:12:34', '2021-03-17 14:58:12', NULL, '0:0:0:0:0:0:0:1', '', 'd9276a29-c0fe-4aeb-a9fa-74fee448f366', '', '', '', 'yaml', '');
INSERT INTO `config_info` VALUES (40, 'mybatis-plus-global-config.yml', 'DEFAULT_GROUP', 'mybatis-plus:\n  global-config:\n    db-config:\n      id-type: auto\n      logic-delete-value: 0\n      logic-not-delete-value: 1', 'b685957fc740dca22a7cc841968272f3', '2020-09-13 00:21:04', '2020-09-13 00:21:04', NULL, '0:0:0:0:0:0:0:1', '', 'd9276a29-c0fe-4aeb-a9fa-74fee448f366', NULL, NULL, NULL, 'yaml', NULL);
INSERT INTO `config_info` VALUES (44, 'renren-fast-datasource.yml', 'dev', 'spring:\n  datasource:\n    type: com.alibaba.druid.pool.DruidDataSource\n    druid:\n      driver-class-name: com.mysql.cj.jdbc.Driver\n      url: jdbc:mysql://127.0.0.1:3306/renren_fast?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai\n      username: root\n      password: orochi0208\n      initial-size: 10\n      max-active: 100\n      min-idle: 10\n      max-wait: 60000\n      pool-prepared-statements: true\n      max-pool-prepared-statement-per-connection-size: 20\n      time-between-eviction-runs-millis: 60000\n      min-evictable-idle-time-millis: 300000\n      #Oracle需要打开注释\n      #validation-query: SELECT 1 FROM DUAL\n      test-while-idle: true\n      test-on-borrow: false\n      test-on-return: false\n      stat-view-servlet:\n        enabled: true\n        url-pattern: /druid/*\n        #login-username: admin\n        #login-password: admin\n      filter:\n        stat:\n          log-slow-sql: true\n          slow-sql-millis: 1000\n          merge-sql: false\n        wall:\n          config:\n            multi-statement-allow: true\n  redis:\n    host: 192.168.50.190\n    port: 6379\n    database: 5\n\n##多数据源的配置\n#dynamic:\n#  datasource:\n#    slave1:\n#      driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver\n#      url: jdbc:sqlserver://localhost:1433;DatabaseName=renren_security\n#      username: sa\n#      password: 123456\n#    slave2:\n#      driver-class-name: org.postgresql.Driver\n#      url: jdbc:postgresql://localhost:5432/renren_security\n#      username: renren\n#      password: 123456', '448c64a411d5b3720090aa07b1a44504', '2020-09-13 05:23:20', '2021-03-17 14:58:29', NULL, '0:0:0:0:0:0:0:1', '', '1d3a0969-c741-4378-bd59-5e12f9774955', '', '', '', 'yaml', '');
INSERT INTO `config_info` VALUES (56, 'product-service-datasource.yml', 'dev', 'spring:\n  datasource:\n    type: com.alibaba.druid.pool.DruidDataSource\n#    #MySQL配置\n    driverClassName: com.p6spy.engine.spy.P6SpyDriver\n    url: jdbc:p6spy:mysql://127.0.0.1:3306/mall_pms?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=Asia/Shanghai\n    username: root\n    password: orochi0208\n  redis:\n    host: 192.168.50.190\n    port: 6379\n    database: 5    \nmybatis-plus:\n  global-config:\n    db-config:\n      id-type: AUTO\n      logic-delete-value: 0\n      logic-not-delete-value: 1', '2b143981a03a510a70e8eda82149ce82', '2020-09-17 06:34:54', '2021-03-17 14:58:44', NULL, '0:0:0:0:0:0:0:1', '', 'b2ad45ca-8e05-46c3-8335-109cf7ede81c', '', '', '', 'yaml', '');
INSERT INTO `config_info` VALUES (60, 'ali-oss-access-info.yml', 'dev', 'alibaba:\n  cloud:\n    access-key: LTAI4G5bG4akBEQF8DgfyaWM\n    secret-key: FXHde8zXyo4p8sDNtlzXANfVbv5pGZ\n    oss:\n      endpoint: oss-cn-beijing.aliyuncs.com\n      bucket: guli-mall-luo # 这个是我手动加上的，并非原生\n      # userDirPrefix: user-dir-prefix/ 因为建议使用动态时间，所以就直接在代码里配置了', '357b07087a4dc11c4f284cca83cf2eff', '2020-09-18 23:48:03', '2020-09-19 02:10:46', NULL, '0:0:0:0:0:0:0:1', '', '6e1e7aea-ca30-493d-a3bf-db9963f79fcd', '', '', '', 'yaml', '');
INSERT INTO `config_info` VALUES (65, 'coupon-service-datasource.yml', 'dev', 'spring:\n  datasource:\n    type: com.alibaba.druid.pool.DruidDataSource\n#    #MySQL配置\n    driverClassName: com.p6spy.engine.spy.P6SpyDriver\n    url: jdbc:p6spy:mysql://127.0.0.1:3306/mall_sms?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=Asia/Shanghai\n    username: root\n    password: orochi0208\n  redis:\n    host: 192.168.50.190\n    port: 6379\n    database: 5  \nmybatis-plus:\n  global-config:\n    db-config:\n      id-type: AUTO\n      logic-delete-value: 0\n      logic-not-delete-value: 1', 'ef8b16b5b7195d09ef25c5f9f7c15730', '2020-09-29 13:43:06', '2021-03-17 14:57:44', NULL, '0:0:0:0:0:0:0:1', '', 'c845691c-f945-43e5-bc98-47216dde9988', '', '', '', 'yaml', '');
INSERT INTO `config_info` VALUES (67, 'ware-service-datasource.yml', 'dev', 'spring:\n  datasource:\n    type: com.alibaba.druid.pool.DruidDataSource\n#    #MySQL配置\n    driverClassName: com.p6spy.engine.spy.P6SpyDriver\n    url: jdbc:p6spy:mysql://127.0.0.1:3306/gulimall_wms?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=Asia/Shanghai\n    username: root\n    password: orochi0208\n  redis:\n    host: 192.168.50.190\n    port: 6379\n    database: 5  ', '84d8ef9425bde386bf890d5f1ee83ace', '2020-09-29 14:28:35', '2021-03-17 14:59:07', NULL, '0:0:0:0:0:0:0:1', '', 'e2ddd38e-3b4b-4bd0-9fcc-68ce6406949e', '', '', '', 'yaml', '');
INSERT INTO `config_info` VALUES (70, 'actuator-admin-client.yml', 'DEFAULT_GROUP', 'spring:  \n  boot:\n    admin:\n      client:\n        url: http://10.2.32.33:9090 # 大部分情况不支持 127.0.0.1 ，建议写真实的ip地址\n\n# 配置访问端点的根路径（/actuator是默认路径）\nmanagement:\n  endpoints:\n    web:\n      base-path: /actuator\n      exposure:\n        include: \"*\"\n        #        yml中的 * 需要用\"\"包括，但是properties中就不用\n        #表示开始所有端点，在开启所有端点的基础上，可以用exclude: 来进行排除\n#        exclude: env,beans,info\n#        include: health,env,info,beans #开启指定端点的访问\n#      默认只开启了两个端点 http://127.0.0.1:8080/actuator/health\n#                         http://127.0.0.1:8080/actuator/info\n# 配置开启其他端点，总共有13个端点', '634bbde7f3bd50c2a9776ce9ccf28cc6', '2020-10-11 06:06:29', '2020-10-11 06:06:29', NULL, '0:0:0:0:0:0:0:1', '', 'b2ad45ca-8e05-46c3-8335-109cf7ede81c', NULL, NULL, NULL, 'yaml', NULL);
INSERT INTO `config_info` VALUES (71, 'actuator-admin-client.yml', 'DEFAULT_GROUP', 'spring:  \n  boot:\n    admin:\n      client:\n        url: http://10.2.32.33:9090 # 大部分情况不支持 127.0.0.1 ，建议写真实的ip地址\n\n# 配置访问端点的根路径（/actuator是默认路径）\nmanagement:\n  endpoints:\n    web:\n      base-path: /actuator\n      exposure:\n        include: \"*\"\n        #        yml中的 * 需要用\"\"包括，但是properties中就不用\n        #表示开始所有端点，在开启所有端点的基础上，可以用exclude: 来进行排除\n#        exclude: env,beans,info\n#        include: health,env,info,beans #开启指定端点的访问\n#      默认只开启了两个端点 http://127.0.0.1:8080/actuator/health\n#                         http://127.0.0.1:8080/actuator/info\n# 配置开启其他端点，总共有13个端点', '634bbde7f3bd50c2a9776ce9ccf28cc6', '2020-10-11 06:11:54', '2020-10-11 06:11:54', NULL, '0:0:0:0:0:0:0:1', '', 'd9276a29-c0fe-4aeb-a9fa-74fee448f366', NULL, NULL, NULL, 'yaml', NULL);
INSERT INTO `config_info` VALUES (72, 'member-service-datasource.yml', 'dev', 'spring:\n  datasource:\n    type: com.alibaba.druid.pool.DruidDataSource\n#    #MySQL配置\n    driverClassName: com.p6spy.engine.spy.P6SpyDriver\n    url: jdbc:p6spy:mysql://127.0.0.1:3306/mall_member?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=Asia/Shanghai\n    username: root\n    password: orochi0208\n  redis:\n    host: 192.168.50.190\n    port: 6379\n    database: 5    \nmybatis-plus:\n  global-config:\n    db-config:\n      id-type: AUTO\n      logic-delete-value: 0\n      logic-not-delete-value: 1', '4ca1412467964cab3bcfc073a61d42ff', '2020-10-18 10:51:14', '2021-03-17 14:59:19', NULL, '0:0:0:0:0:0:0:1', '', '0454b10c-87e5-463f-a27b-dcf700189310', '', '', '', 'yaml', '');
INSERT INTO `config_info` VALUES (74, 'order-service-datasource.yml', 'dev', 'spring:\n  datasource:\n    type: com.alibaba.druid.pool.DruidDataSource\n#    #MySQL配置\n    driverClassName: com.p6spy.engine.spy.P6SpyDriver\n    url: jdbc:p6spy:mysql://127.0.0.1:3306/mall_oms?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=Asia/Shanghai\n    username: root\n    password: orochi0208\n  redis:\n    host: 192.168.50.190\n    port: 6379\n    database: 5  \nmybatis-plus:\n  global-config:\n    db-config:\n      id-type: AUTO\n      logic-delete-value: 0\n      logic-not-delete-value: 1', '2c385a6b5798bd752cd76b91eab6d323', '2020-11-19 09:20:54', '2021-03-17 14:59:32', NULL, '0:0:0:0:0:0:0:1', '', '27260bd5-9f5b-4eee-9c5e-5cc64242da80', '', '', '', 'yaml', '');
COMMIT;

-- ----------------------------
-- Table structure for config_info_aggr
-- ----------------------------
DROP TABLE IF EXISTS `config_info_aggr`;
CREATE TABLE `config_info_aggr` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `data_id` varchar(255) COLLATE utf8_bin NOT NULL COMMENT 'data_id',
  `group_id` varchar(255) COLLATE utf8_bin NOT NULL COMMENT 'group_id',
  `datum_id` varchar(255) COLLATE utf8_bin NOT NULL COMMENT 'datum_id',
  `content` longtext COLLATE utf8_bin NOT NULL COMMENT '内容',
  `gmt_modified` datetime NOT NULL COMMENT '修改时间',
  `app_name` varchar(128) COLLATE utf8_bin DEFAULT NULL,
  `tenant_id` varchar(128) COLLATE utf8_bin DEFAULT '' COMMENT '租户字段',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_configinfoaggr_datagrouptenantdatum` (`data_id`,`group_id`,`tenant_id`,`datum_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='增加租户字段';

-- ----------------------------
-- Records of config_info_aggr
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for config_info_beta
-- ----------------------------
DROP TABLE IF EXISTS `config_info_beta`;
CREATE TABLE `config_info_beta` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `data_id` varchar(255) COLLATE utf8_bin NOT NULL COMMENT 'data_id',
  `group_id` varchar(128) COLLATE utf8_bin NOT NULL COMMENT 'group_id',
  `app_name` varchar(128) COLLATE utf8_bin DEFAULT NULL COMMENT 'app_name',
  `content` longtext COLLATE utf8_bin NOT NULL COMMENT 'content',
  `beta_ips` varchar(1024) COLLATE utf8_bin DEFAULT NULL COMMENT 'betaIps',
  `md5` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT 'md5',
  `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  `src_user` text COLLATE utf8_bin COMMENT 'source user',
  `src_ip` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT 'source ip',
  `tenant_id` varchar(128) COLLATE utf8_bin DEFAULT '' COMMENT '租户字段',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_configinfobeta_datagrouptenant` (`data_id`,`group_id`,`tenant_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='config_info_beta';

-- ----------------------------
-- Records of config_info_beta
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for config_info_tag
-- ----------------------------
DROP TABLE IF EXISTS `config_info_tag`;
CREATE TABLE `config_info_tag` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `data_id` varchar(255) COLLATE utf8_bin NOT NULL COMMENT 'data_id',
  `group_id` varchar(128) COLLATE utf8_bin NOT NULL COMMENT 'group_id',
  `tenant_id` varchar(128) COLLATE utf8_bin DEFAULT '' COMMENT 'tenant_id',
  `tag_id` varchar(128) COLLATE utf8_bin NOT NULL COMMENT 'tag_id',
  `app_name` varchar(128) COLLATE utf8_bin DEFAULT NULL COMMENT 'app_name',
  `content` longtext COLLATE utf8_bin NOT NULL COMMENT 'content',
  `md5` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT 'md5',
  `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  `src_user` text COLLATE utf8_bin COMMENT 'source user',
  `src_ip` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT 'source ip',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_configinfotag_datagrouptenanttag` (`data_id`,`group_id`,`tenant_id`,`tag_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='config_info_tag';

-- ----------------------------
-- Records of config_info_tag
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for config_tags_relation
-- ----------------------------
DROP TABLE IF EXISTS `config_tags_relation`;
CREATE TABLE `config_tags_relation` (
  `id` bigint NOT NULL COMMENT 'id',
  `tag_name` varchar(128) COLLATE utf8_bin NOT NULL COMMENT 'tag_name',
  `tag_type` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT 'tag_type',
  `data_id` varchar(255) COLLATE utf8_bin NOT NULL COMMENT 'data_id',
  `group_id` varchar(128) COLLATE utf8_bin NOT NULL COMMENT 'group_id',
  `tenant_id` varchar(128) COLLATE utf8_bin DEFAULT '' COMMENT 'tenant_id',
  `nid` bigint NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`nid`),
  UNIQUE KEY `uk_configtagrelation_configidtag` (`id`,`tag_name`,`tag_type`),
  KEY `idx_tenant_id` (`tenant_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='config_tag_relation';

-- ----------------------------
-- Records of config_tags_relation
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for group_capacity
-- ----------------------------
DROP TABLE IF EXISTS `group_capacity`;
CREATE TABLE `group_capacity` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `group_id` varchar(128) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT 'Group ID，空字符表示整个集群',
  `quota` int unsigned NOT NULL DEFAULT '0' COMMENT '配额，0表示使用默认值',
  `usage` int unsigned NOT NULL DEFAULT '0' COMMENT '使用量',
  `max_size` int unsigned NOT NULL DEFAULT '0' COMMENT '单个配置大小上限，单位为字节，0表示使用默认值',
  `max_aggr_count` int unsigned NOT NULL DEFAULT '0' COMMENT '聚合子配置最大个数，，0表示使用默认值',
  `max_aggr_size` int unsigned NOT NULL DEFAULT '0' COMMENT '单个聚合数据的子配置大小上限，单位为字节，0表示使用默认值',
  `max_history_count` int unsigned NOT NULL DEFAULT '0' COMMENT '最大变更历史数量',
  `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_group_id` (`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='集群、各Group容量信息表';

-- ----------------------------
-- Records of group_capacity
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for his_config_info
-- ----------------------------
DROP TABLE IF EXISTS `his_config_info`;
CREATE TABLE `his_config_info` (
  `id` bigint unsigned NOT NULL,
  `nid` bigint unsigned NOT NULL AUTO_INCREMENT,
  `data_id` varchar(255) COLLATE utf8_bin NOT NULL,
  `group_id` varchar(128) COLLATE utf8_bin NOT NULL,
  `app_name` varchar(128) COLLATE utf8_bin DEFAULT NULL COMMENT 'app_name',
  `content` longtext COLLATE utf8_bin NOT NULL,
  `md5` varchar(32) COLLATE utf8_bin DEFAULT NULL,
  `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `src_user` text COLLATE utf8_bin,
  `src_ip` varchar(20) COLLATE utf8_bin DEFAULT NULL,
  `op_type` char(10) COLLATE utf8_bin DEFAULT NULL,
  `tenant_id` varchar(128) COLLATE utf8_bin DEFAULT '' COMMENT '租户字段',
  PRIMARY KEY (`nid`),
  KEY `idx_gmt_create` (`gmt_create`),
  KEY `idx_gmt_modified` (`gmt_modified`),
  KEY `idx_did` (`data_id`)
) ENGINE=InnoDB AUTO_INCREMENT=236 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='多租户改造';

-- ----------------------------
-- Records of his_config_info
-- ----------------------------
BEGIN;
INSERT INTO `his_config_info` VALUES (65, 229, 'coupon-service-datasource.yml', 'dev', '', 'spring:\n  datasource:\n    type: com.alibaba.druid.pool.DruidDataSource\n#    #MySQL配置\n    driverClassName: com.p6spy.engine.spy.P6SpyDriver\n    url: jdbc:p6spy:mysql://127.0.0.1:3306/mall_sms?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=Asia/Shanghai\n    username: root\n    password: orochi0208\nmybatis-plus:\n  global-config:\n    db-config:\n      id-type: AUTO\n      logic-delete-value: 0\n      logic-not-delete-value: 1', '5162390de6f89c2ccd44e68e62304e9d', '2021-03-17 22:57:44', '2021-03-17 14:57:44', NULL, '0:0:0:0:0:0:0:1', 'U', 'c845691c-f945-43e5-bc98-47216dde9988');
INSERT INTO `his_config_info` VALUES (35, 230, 'product-category-service.yml', 'dev', '', 'spring:\n  datasource:\n    type: com.alibaba.druid.pool.DruidDataSource\n#    #MySQL配置\n    driverClassName: com.p6spy.engine.spy.P6SpyDriver\n    url: jdbc:p6spy:mysql://127.0.0.1:3306/pms_category?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=Asia/Shanghai\n    username: root\n    password: orochi0208', '5cc296cbfed0a805a8e1994e57403913', '2021-03-17 22:58:11', '2021-03-17 14:58:12', NULL, '0:0:0:0:0:0:0:1', 'U', 'd9276a29-c0fe-4aeb-a9fa-74fee448f366');
INSERT INTO `his_config_info` VALUES (44, 231, 'renren-fast-datasource.yml', 'dev', '', 'spring:\n  datasource:\n    type: com.alibaba.druid.pool.DruidDataSource\n    druid:\n      driver-class-name: com.mysql.cj.jdbc.Driver\n      url: jdbc:mysql://127.0.0.1:3306/renren_fast?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai\n      username: root\n      password: orochi0208\n      initial-size: 10\n      max-active: 100\n      min-idle: 10\n      max-wait: 60000\n      pool-prepared-statements: true\n      max-pool-prepared-statement-per-connection-size: 20\n      time-between-eviction-runs-millis: 60000\n      min-evictable-idle-time-millis: 300000\n      #Oracle需要打开注释\n      #validation-query: SELECT 1 FROM DUAL\n      test-while-idle: true\n      test-on-borrow: false\n      test-on-return: false\n      stat-view-servlet:\n        enabled: true\n        url-pattern: /druid/*\n        #login-username: admin\n        #login-password: admin\n      filter:\n        stat:\n          log-slow-sql: true\n          slow-sql-millis: 1000\n          merge-sql: false\n        wall:\n          config:\n            multi-statement-allow: true\n\n\n##多数据源的配置\n#dynamic:\n#  datasource:\n#    slave1:\n#      driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver\n#      url: jdbc:sqlserver://localhost:1433;DatabaseName=renren_security\n#      username: sa\n#      password: 123456\n#    slave2:\n#      driver-class-name: org.postgresql.Driver\n#      url: jdbc:postgresql://localhost:5432/renren_security\n#      username: renren\n#      password: 123456', '4055f4fb794d0dfd438e84ebddfc9970', '2021-03-17 22:58:29', '2021-03-17 14:58:29', NULL, '0:0:0:0:0:0:0:1', 'U', '1d3a0969-c741-4378-bd59-5e12f9774955');
INSERT INTO `his_config_info` VALUES (56, 232, 'product-service-datasource.yml', 'dev', '', 'spring:\n  datasource:\n    type: com.alibaba.druid.pool.DruidDataSource\n#    #MySQL配置\n    driverClassName: com.p6spy.engine.spy.P6SpyDriver\n    url: jdbc:p6spy:mysql://127.0.0.1:3306/mall_pms?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=Asia/Shanghai\n    username: root\n    password: orochi0208\nmybatis-plus:\n  global-config:\n    db-config:\n      id-type: AUTO\n      logic-delete-value: 0\n      logic-not-delete-value: 1', '37e5c03f51799e679f7fb762e6662169', '2021-03-17 22:58:44', '2021-03-17 14:58:44', NULL, '0:0:0:0:0:0:0:1', 'U', 'b2ad45ca-8e05-46c3-8335-109cf7ede81c');
INSERT INTO `his_config_info` VALUES (67, 233, 'ware-service-datasource.yml', 'dev', '', 'spring:\n  datasource:\n    type: com.alibaba.druid.pool.DruidDataSource\n#    #MySQL配置\n    driverClassName: com.p6spy.engine.spy.P6SpyDriver\n    url: jdbc:p6spy:mysql://127.0.0.1:3306/gulimall_wms?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=Asia/Shanghai\n    username: root\n    password: orochi0208', '402cec9605a8eb7de69f73c262664ea5', '2021-03-17 22:59:07', '2021-03-17 14:59:07', NULL, '0:0:0:0:0:0:0:1', 'U', 'e2ddd38e-3b4b-4bd0-9fcc-68ce6406949e');
INSERT INTO `his_config_info` VALUES (72, 234, 'member-service-datasource.yml', 'dev', '', 'spring:\n  datasource:\n    type: com.alibaba.druid.pool.DruidDataSource\n#    #MySQL配置\n    driverClassName: com.p6spy.engine.spy.P6SpyDriver\n    url: jdbc:p6spy:mysql://127.0.0.1:3306/mall_member?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=Asia/Shanghai\n    username: root\n    password: orochi0208\nmybatis-plus:\n  global-config:\n    db-config:\n      id-type: AUTO\n      logic-delete-value: 0\n      logic-not-delete-value: 1', '0a999c36e348bf820c950df139305967', '2021-03-17 22:59:19', '2021-03-17 14:59:19', NULL, '0:0:0:0:0:0:0:1', 'U', '0454b10c-87e5-463f-a27b-dcf700189310');
INSERT INTO `his_config_info` VALUES (74, 235, 'order-service-datasource.yml', 'dev', '', 'spring:\n  datasource:\n    type: com.alibaba.druid.pool.DruidDataSource\n#    #MySQL配置\n    driverClassName: com.p6spy.engine.spy.P6SpyDriver\n    url: jdbc:p6spy:mysql://127.0.0.1:3306/mall_oms?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=Asia/Shanghai\n    username: root\n    password: orochi0208\nmybatis-plus:\n  global-config:\n    db-config:\n      id-type: AUTO\n      logic-delete-value: 0\n      logic-not-delete-value: 1', 'd492063764e66cd4f3b34eb28231f9f6', '2021-03-17 22:59:32', '2021-03-17 14:59:32', NULL, '0:0:0:0:0:0:0:1', 'U', '27260bd5-9f5b-4eee-9c5e-5cc64242da80');
COMMIT;

-- ----------------------------
-- Table structure for permissions
-- ----------------------------
DROP TABLE IF EXISTS `permissions`;
CREATE TABLE `permissions` (
  `role` varchar(50) NOT NULL,
  `resource` varchar(255) NOT NULL,
  `action` varchar(8) NOT NULL,
  UNIQUE KEY `uk_role_permission` (`role`,`resource`,`action`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of permissions
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for roles
-- ----------------------------
DROP TABLE IF EXISTS `roles`;
CREATE TABLE `roles` (
  `username` varchar(50) NOT NULL,
  `role` varchar(50) NOT NULL,
  UNIQUE KEY `idx_user_role` (`username`,`role`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of roles
-- ----------------------------
BEGIN;
INSERT INTO `roles` VALUES ('nacos', 'ROLE_ADMIN');
COMMIT;

-- ----------------------------
-- Table structure for tenant_capacity
-- ----------------------------
DROP TABLE IF EXISTS `tenant_capacity`;
CREATE TABLE `tenant_capacity` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `tenant_id` varchar(128) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT 'Tenant ID',
  `quota` int unsigned NOT NULL DEFAULT '0' COMMENT '配额，0表示使用默认值',
  `usage` int unsigned NOT NULL DEFAULT '0' COMMENT '使用量',
  `max_size` int unsigned NOT NULL DEFAULT '0' COMMENT '单个配置大小上限，单位为字节，0表示使用默认值',
  `max_aggr_count` int unsigned NOT NULL DEFAULT '0' COMMENT '聚合子配置最大个数',
  `max_aggr_size` int unsigned NOT NULL DEFAULT '0' COMMENT '单个聚合数据的子配置大小上限，单位为字节，0表示使用默认值',
  `max_history_count` int unsigned NOT NULL DEFAULT '0' COMMENT '最大变更历史数量',
  `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_tenant_id` (`tenant_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='租户容量信息表';

-- ----------------------------
-- Records of tenant_capacity
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for tenant_info
-- ----------------------------
DROP TABLE IF EXISTS `tenant_info`;
CREATE TABLE `tenant_info` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `kp` varchar(128) COLLATE utf8_bin NOT NULL COMMENT 'kp',
  `tenant_id` varchar(128) COLLATE utf8_bin DEFAULT '' COMMENT 'tenant_id',
  `tenant_name` varchar(128) COLLATE utf8_bin DEFAULT '' COMMENT 'tenant_name',
  `tenant_desc` varchar(256) COLLATE utf8_bin DEFAULT NULL COMMENT 'tenant_desc',
  `create_source` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT 'create_source',
  `gmt_create` bigint NOT NULL COMMENT '创建时间',
  `gmt_modified` bigint NOT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_tenant_info_kptenantid` (`kp`,`tenant_id`),
  KEY `idx_tenant_id` (`tenant_id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='tenant_info';

-- ----------------------------
-- Records of tenant_info
-- ----------------------------
BEGIN;
INSERT INTO `tenant_info` VALUES (4, '1', '62664db1-9168-4f61-8c19-032ebfd6b6a2', 'api-gateway', '网关命名空间', 'nacos', 1599789822749, 1599789822749);
INSERT INTO `tenant_info` VALUES (5, '1', 'd9276a29-c0fe-4aeb-a9fa-74fee448f366', 'product-category', '商品目录命名空间', 'nacos', 1599826235571, 1599826235571);
INSERT INTO `tenant_info` VALUES (6, '1', '1d3a0969-c741-4378-bd59-5e12f9774955', 'renren-fast-service', '人人-fast-服务命名空间', 'nacos', 1599974491990, 1599974491990);
INSERT INTO `tenant_info` VALUES (7, '1', 'b2ad45ca-8e05-46c3-8335-109cf7ede81c', 'product-service', '商品服务', 'nacos', 1600324447990, 1600324447990);
INSERT INTO `tenant_info` VALUES (8, '1', '6e1e7aea-ca30-493d-a3bf-db9963f79fcd', 'aliyun-oss-service', '阿里对象存储服务命名空间', 'nacos', 1600472697147, 1600472697147);
INSERT INTO `tenant_info` VALUES (9, '1', 'c845691c-f945-43e5-bc98-47216dde9988', 'coupon-service', '优惠卷的命名空间', 'nacos', 1601386944893, 1601386944893);
INSERT INTO `tenant_info` VALUES (10, '1', 'e2ddd38e-3b4b-4bd0-9fcc-68ce6406949e', 'ware-service', '库存系统的命名空间', 'nacos', 1601389678917, 1601389678917);
INSERT INTO `tenant_info` VALUES (11, '1', '0454b10c-87e5-463f-a27b-dcf700189310', 'member-service', '会员服务的命名空间', 'nacos', 1603018246193, 1603018246193);
INSERT INTO `tenant_info` VALUES (12, '1', '27260bd5-9f5b-4eee-9c5e-5cc64242da80', 'order-service', '订单服务的命名空间', 'nacos', 1605777630485, 1605777630485);
INSERT INTO `tenant_info` VALUES (13, '1', '65308ef0-f76d-4435-98e6-e1211a2e5b65', 'seata-server', 'seata-服务器的命名空间', 'nacos', 1606098663215, 1606098663215);
INSERT INTO `tenant_info` VALUES (14, '1', '3155b515-375b-4cd2-8144-93ab83a15d5a', 'secKill-service', '秒杀微服务的命名空间', 'nacos', 1606707143496, 1606707143496);
COMMIT;

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `username` varchar(50) NOT NULL,
  `password` varchar(500) NOT NULL,
  `enabled` tinyint(1) NOT NULL,
  PRIMARY KEY (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of users
-- ----------------------------
BEGIN;
INSERT INTO `users` VALUES ('nacos', '$2a$10$EuWPZHzz32dJN7jexM34MOeYirDdFAZm2kuWj7VEOJhhZkDrxfvUu', 1);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
